package com.cqut.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.cqut.pojo.vo.noticeInfoVO;

public interface NoticeManagerMapperExtra {

	List<noticeInfoVO> findNotices(
			@Param("noticeType")
			Integer noticeType, 
			@Param("noticeTitle")
			String noticeTitle,
			@Param("start")
			int start,
			@Param("end")
			int end);

	String findNoticesNo(
			@Param("noticeType")
			Integer noticeType, 
			@Param("noticeTitle")
			String noticeTitle,
			@Param("start")
			int start,
			@Param("end")
			int end);

	Map<String, Object> getNoticeById(
			@Param("noticeId")
			String noticeId);
	
	Map<String, Object> getOnwerById(
			@Param("noticeId")
			String noticeId);

	List<Map<String, Object>> getCompetition(
			@Param("userId")
			String userId);

	List<noticeInfoVO> findNoticesStates(
		@Param("noticeType")
		Integer noticeType, 
		@Param("noticeTitle")
		String noticeTitle,
		@Param("start")
		int start,
		@Param("end")
		int end);

	String findNoticesStatesNo(
			@Param("noticeType")
			Integer noticeType, 
			@Param("noticeTitle")
			String noticeTitle,
			@Param("start")
			int start,
			@Param("end")
			int end);

	List<Map<String, Object>> getNoticeStateUser(
			@Param("userId")
			String userId,
			@Param("start")
			int start,
			@Param("end")
			int end);

	String findNoticesStatesUserNo(@Param("userId")
			String userId,
			@Param("start")
			int start,
			@Param("end")
			int end);


}
